# Define here the models for your scraped items
#
# See documentation in:
# https://docs.scrapy.org/en/latest/topics/items.html

import scrapy
from stock_data_xuweijie.items import stock_data_xuweijieItem

class StockDataxuweijieItem(scrapy.Item):
    name = 'tonghuashun'
    stockCode = scrapy.Field()

    price = scrapy.Field()

    zhangdiefu = scrapy.Field()

    huanshoulv = scrapy.Field()

    zijin = scrapy.Field()

    rand = scrapy.Field()

    allowed_domains = ['10jqka.com.cn']

    url = 'http://data.10jqka.com.cn/market/zdfph/'
    start_urls = [url]

    def parse(self, response):

        # with open("zdfph.html", "w", encoding="utf-8") as file:
        #     file.write(response.text)
        # //*[@id="J-ajax-main"]/table/tbody/tr[1]
        # //*[@id="J-ajax-main"]/table/tbody/tr[1]/td[3]/a
        stock_data_list = []
        for each in response.xpath("//*[@id=\"J-ajax-main\"]/table/tbody/tr"):
            # print("================================")

            name = each.xpath("td[3]/a/text()").extract()[0]
            # print(name)

            stockCode = each.xpath("td[2]/a/text()").extract()[0]
            # print(stockCode)

            price = each.xpath("td[4]/a/text()").extract()[0]
            # print(price)

            zhangdiefu = each.xpath("td[5]/a/text()").extract()[0]
            # print(zhangdiefu)

            huanshoulv = each.xpath("td[8]/a/text()").extract()[0]
            # print(huanshoulv)

            zijin = each.xpath("td[11]/a/text()").extract()[0]
            # print(zijin)
            rand = each.xpath("td[3]/a/text()").extract()[0]
            # print(rand)

            item = StockDataxuweijieItem()
            item['name'] = name
            item['stockCode'] = stockCode
            item['price'] = price
            item['zhangdiefu'] = zhangdiefu
            item['huanshoulv'] = huanshoulv
            item['zijin'] = zijin
            item['rand'] = rand

            stock_data_list.append(item)
        return stock_data_list
